package com.baohua.dao;

import java.util.List;

import com.baohua.model.Member;

/**
 * 会员的Dao接口
 * author dengliang
 * */
public interface MemberDao {

	/**
	 * 根据SQL语句查询会员列表
	 * @return
	 */
	public List<Member> queryMember(String sql, int page, int pageSize);
	
	/**
	 * 根据会员编号查询会员
	 * @param menberNo
	 * @return
	 */
	public Member queryMemberBymenberNo(String memberNo);
	
	/**
	 * 根据员工姓名查询员工
	 * @param memberName
	 * @return
	 */
	public Member queryMemberByMemberName(String memberName);
	
	/**
	 * 增加员工
	 * @param Member
	 */
	public void addMember(Member member);
	
	/**
	 * 删除员工
	 * @param staff
	 */
	public void delMember(Member member);
	
	/**
	 * 修改员工
	 * @param staff
	 */
	public void updateMember(Member member);
	
	/**
	 * 统计员工总数
	 * @return
	 */
	public long countMember(String sql);
	
	/**
	 * 根据员工Id进行查询
	 * @param memberId
	 * @return
	 */
	public Member queryMemberByMemberId(int memberId);
	
}
